package com.jic.veteran.dao;

import com.jic.veteran.model.DonatePayDetail;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface DonatePayDetailDao {
    int insert(@Param("item") DonatePayDetail donatePayDetail);
    String getMaxAmt(@Param("startDate") String startDate,@Param("endDate") String endDate);
    List<Map> getSumDataByDate(@Param("startDate") String startDate,@Param("endDate") String endDate);
    List<DonatePayDetail> getItemByTrxidByStatus(@Param("trxid") String trxid, @Param("payStatus") String payStatus);
    DonatePayDetail getItemByReqsn(@Param("reqsn") String reqsn);
    List<DonatePayDetail> getItemByStatus();
    List<DonatePayDetail> getItemsForRecon(@Param("trxdate") String trxdate);
    Map<String,String> getSumTotalForRecon(@Param("trxdate") String trxdate);
    List<Map<String,String>> getItemsUnSuccess(@Param("trxdate") String trxdate);
    DonatePayDetail getItemForRecon(@Param("trxid") String trxid, @Param("reqsn") String reqsn);
}
